SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwtTramitesResiduales
AS
SELECT        dbo.tb_TramitesResiduales.ID, dbo.tb_TramitesResiduales.Codigo, dbo.tb_TramitesResiduales.Tema, dbo.tb_TramitesResiduales.FechaInicio, 
                         dbo.tb_TramitesResiduales.FechaFin, dbo.tb_TramitesResiduales.Fojas,
                         dbo.tb_TiposTramitesResiduales.Descripcion
FROM            dbo.tb_TramitesResiduales INNER JOIN
                         dbo.tb_TiposTramitesResiduales ON dbo.tb_TramitesResiduales.TipoTramite = dbo.tb_TiposTramitesResiduales.ID
GO
GRANT SELECT ON  [dbo].[vwtTramitesResiduales] TO [AdministracionSagenet]
GRANT SELECT ON  [dbo].[vwtTramitesResiduales] TO [Tramites]
GO
